SELECT ID, SUM(VALUE1 + VALUE2) FROM tableName GROUP BY ID --or simple addition SELECT ID, (VALUE1 + VALUE2) as AddedValues FROM tableName